package org.zh.sh.entity;

public class Teacher {
    /**
     * 住址-->varchar-->varchar(100)-->-->     */
    public static final String teacherAddress = "teacherAddress";
    /**
     * 年龄-->tinyint-->tinyint unsigned-->MUL-->     */
    public static final String teacherAge = "teacherAge";
    /**
     * 出生日期-->datetime-->datetime-->MUL-->     */
    public static final String teacherBirthday = "teacherBirthday";
    /**
     * 学历-->varchar-->varchar(20)-->-->     */
    public static final String teacherEducationalBackground = "teacherEducationalBackground";
    /**
     * 邮箱地址-->varchar-->varchar(50)-->-->     */
    public static final String teacherEmail = "teacherEmail";
    /**
     * 民族-->varchar-->varchar(20)-->-->     */
    public static final String teacherEthnicGroup = "teacherEthnicGroup";
    /**
     * 性别-->set-->set('男','女')-->MUL-->     */
    public static final String teacherGender = "teacherGender";
    /**
     * 教师的兴趣爱好-->varchar-->varchar(50)-->-->     */
    public static final String teacherHobbies = "teacherHobbies";
    /**
     * 教师ID-->int-->int unsigned-->PRI-->auto_increment     */
    public static final String teacherId = "teacherId";
    /**
     * 身份证号码-->char-->char(18)-->UNI-->     */
    public static final String teacherIdentityCard = "teacherIdentityCard";
    /**
     * 名字-->varchar-->varchar(20)-->MUL-->     */
    public static final String teacherName = "teacherName";
    /**
     * 国籍-->varchar-->varchar(20)-->MUL-->     */
    public static final String teacherNationality = "teacherNationality";
    /**
     * 入职时间-->datetime-->datetime-->MUL-->     */
    public static final String teacherOnboardingDate = "teacherOnboardingDate";
    /**
     * 电话号码-->char-->char(11)-->UNI-->     */
    public static final String teacherPhoneNumber = "teacherPhoneNumber";
    /**
     * 工资-->decimal-->decimal(10,3)-->-->     */
    public static final String teacherSalary = "teacherSalary";
    /**
     * 毕业于哪个学校-->varchar-->varchar(50)-->-->     */
    public static final String teacherSchool = "teacherSchool";
    /**
     * 特长-->varchar-->varchar(100)-->-->     */
    public static final String teacherSpecialty = "teacherSpecialty";
    /**
     * 教师资格证书-->varchar-->varchar(50)-->-->     */
    public static final String teacherTeachingCertificate = "teacherTeachingCertificate";

    public static final String tableName = "teacher";
    public static final String queryById = "select * from teacher where teacherId = ?";
    public static final String deleteById = "delete from teacher where teacherId = ?";
    public static final String updateAll = "update teacher set teacherAddress= ? ,teacherAge= ? ,teacherBirthday= ? ,teacherEducationalBackground= ? ,teacherEmail= ? ,teacherEthnicGroup= ? ,teacherGender= ? ,teacherHobbies= ? ,teacherIdentityCard= ? ,teacherName= ? ,teacherNationality= ? ,teacherOnboardingDate= ? ,teacherPhoneNumber= ? ,teacherSalary= ? ,teacherSchool= ? ,teacherSpecialty= ? ,teacherTeachingCertificate= ?   where teacherId = ?";
}